{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>桥梁名称</th>\n",
       "      <th>单位名称</th>\n",
       "      <th>路线号</th>\n",
       "      <th>跨（孔）号</th>\n",
       "      <th>结构类型</th>\n",
       "      <th>材料</th>\n",
       "      <th>桥面板位置</th>\n",
       "      <th>受力形式</th>\n",
       "      <th>施工方式</th>\n",
       "      <th>跨号列表</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>204国道分离式立交(上行)</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-14 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>部分预应力钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,10,11,12,13,14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>204国道分离式立交(上行)</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>18-29</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>部分预应力钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>18,19,20,21,22,23,24,25,26,27,28,29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>204国道分离式立交(上行)</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>15-17</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>支架现浇</td>\n",
       "      <td>15,16,17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>204国道分离式立交(下行)</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>14-16</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>支架现浇</td>\n",
       "      <td>14,15,16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>204国道分离式立交(下行)</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-13 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>部分预应力钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,10,11,12,13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>204国道分离式立交(下行)</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>17-29</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>部分预应力钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>17,18,19,20,21,22,23,24,25,26,27,28,29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>220分离立交</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-20 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>部分预应力钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>八农中桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-04 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>白石公路分离立交</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>班庄互通C匝道</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-01-04 00:00:00</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>预应力连续</td>\n",
       "      <td>1,2,3,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>板新公路跨主线大桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-13 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>支架现浇</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,10,11,12,13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>板新立交跨陈户大河中桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>潮河口村中桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>陈户大河大桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-07 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3,4,5,6,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>陈户中桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G15|沈海高速</td>\n",
       "      <td>2015-01-05 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制安装</td>\n",
       "      <td>1,2,3,4,5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>城南枢纽A匝道中桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-01-04 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>简支预应力</td>\n",
       "      <td>1,2,3,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>城南枢纽B匝道上跨汾灌高速公路桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-10-13 00:00:00</td>\n",
       "      <td>叠合梁</td>\n",
       "      <td>钢-砼</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>叠合梁</td>\n",
       "      <td>10,11,12,13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>城南枢纽B匝道上跨汾灌高速公路桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>1-9,14-18</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇砼</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,14,15,16,17,18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>城南枢纽B匝道中桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-01-04 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇钢筋砼</td>\n",
       "      <td>1,2,3,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>城南枢纽C匝道桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-01-07 00:00:00</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>预应力现浇</td>\n",
       "      <td>1,2,3,4,5,6,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>城南枢纽D匝道桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-01-04 00:00:00</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>预应力现浇</td>\n",
       "      <td>1,2,3,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>城南枢纽E匝道桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-01-08 00:00:00</td>\n",
       "      <td>现浇钢筋砼连续板梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇钢筋砼</td>\n",
       "      <td>1,2,3,4,5,6,7,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>城南枢纽F匝道</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-01-08 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>搭设支架现浇</td>\n",
       "      <td>1,2,3,4,5,6,7,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>城南枢纽G匝道</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>25-28</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>预应力现浇</td>\n",
       "      <td>25,26,27,28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>城南枢纽G匝道</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-06-09 00:00:00</td>\n",
       "      <td>叠合梁</td>\n",
       "      <td>钢-砼</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>钢梁与砼结合</td>\n",
       "      <td>6,7,8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>城南枢纽G匝道</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>1-5,10-24</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>1,2,3,4,5,10,11,12,13,14,15,16,17,18,19,20,21,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>城南枢纽主线桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>18-21</td>\n",
       "      <td>叠合梁</td>\n",
       "      <td>钢-砼</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续刚构</td>\n",
       "      <td>钢砼结合</td>\n",
       "      <td>18,19,20,21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>城南枢纽主线桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>11-17,22-25</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇连续</td>\n",
       "      <td>11,12,13,14,15,16,17,22,23,24,25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>城南枢纽主线桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>1-2,36-37</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>预应力连续</td>\n",
       "      <td>1,2,36,37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>城南枢纽主线桥</td>\n",
       "      <td>江苏汾灌高速公路有限公司</td>\n",
       "      <td>G25|长深高速</td>\n",
       "      <td>2015-03-10 00:00:00</td>\n",
       "      <td>组合式箱粱</td>\n",
       "      <td>预应力砼组合箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>预制</td>\n",
       "      <td>3,4,5,6,7,8,9,10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6397</th>\n",
       "      <td>大寨河小桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>1</td>\n",
       "      <td>板梁（实心）</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6398</th>\n",
       "      <td>大寨河小桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>3</td>\n",
       "      <td>板梁（实心）</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6399</th>\n",
       "      <td>大寨河小桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2</td>\n",
       "      <td>板梁（实心）</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6400</th>\n",
       "      <td>江阴大桥半路半桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>G2|京沪高速</td>\n",
       "      <td>2015-01-07 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>支架法</td>\n",
       "      <td>1,2,3,4,5,6,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6401</th>\n",
       "      <td>江阴大桥北引桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>G2|京沪高速</td>\n",
       "      <td>2015-01-29 00:00:00</td>\n",
       "      <td>T形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>先预制后拼装</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6402</th>\n",
       "      <td>江阴大桥北引桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>G2|京沪高速</td>\n",
       "      <td>30-34</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>满堂支架现浇</td>\n",
       "      <td>30,31,32,33,34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6403</th>\n",
       "      <td>江阴大桥南引桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>G2|京沪高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6404</th>\n",
       "      <td>山凹口大桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>G2|京沪高速</td>\n",
       "      <td>2015-01-13 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,10,11,12,13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6405</th>\n",
       "      <td>山凹口大桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>G2|京沪高速</td>\n",
       "      <td>14-29</td>\n",
       "      <td>预应力砼现浇箱梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>满堂支架现浇</td>\n",
       "      <td>14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6406</th>\n",
       "      <td>硕放枢纽G匝道1#桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>20-22</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>结构钢</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>顶推施工</td>\n",
       "      <td>20,21,22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6407</th>\n",
       "      <td>硕放枢纽G匝道1#桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>满堂支架现浇砼</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6408</th>\n",
       "      <td>硕放枢纽G匝道1#桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>23-29</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>满堂支架现浇砼</td>\n",
       "      <td>23,24,25,26,27,28,29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6409</th>\n",
       "      <td>硕放枢纽G匝道1#桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-04-19 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>满堂支架现浇砼</td>\n",
       "      <td>4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6410</th>\n",
       "      <td>硕放枢纽H匝道1#桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-08 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>满堂支架现浇砼</td>\n",
       "      <td>1,2,3,4,5,6,7,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6411</th>\n",
       "      <td>硕放枢纽H匝道1#桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>13-16</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>现浇钢筋混凝土箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>满堂支架现浇砼</td>\n",
       "      <td>13,14,15,16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6412</th>\n",
       "      <td>硕放枢纽H匝道1#桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-09-12 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>结构钢</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>顶推施工</td>\n",
       "      <td>9,10,11,12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6413</th>\n",
       "      <td>硕放枢纽O匝道桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-06 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>预应力钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>1,2,3,4,5,6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6414</th>\n",
       "      <td>硕放枢纽P1匝道桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6415</th>\n",
       "      <td>硕放枢纽P2匝道桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-06 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>1,2,3,4,5,6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6416</th>\n",
       "      <td>硕放枢纽主线桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-17 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6417</th>\n",
       "      <td>硕放枢纽主线桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>21-40</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6418</th>\n",
       "      <td>硕放枢纽主线桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>18-20</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>预应力砼组合箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>18,19,20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6419</th>\n",
       "      <td>硕放枢纽主线桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>41-43</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>预应力混凝土连续箱梁</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>41,42,43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6420</th>\n",
       "      <td>硕放枢纽主线桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>44-46</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>连续</td>\n",
       "      <td>现浇</td>\n",
       "      <td>44,45,46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6421</th>\n",
       "      <td>苏家湾中桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>先预制后拼装</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6422</th>\n",
       "      <td>吴花浜中桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>先预制后拼装</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6423</th>\n",
       "      <td>西香湾小桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-03 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制拼装</td>\n",
       "      <td>1,2,3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6424</th>\n",
       "      <td>锡宅路主线上跨桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-01 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制拼装</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6425</th>\n",
       "      <td>兴南路中桥</td>\n",
       "      <td>江苏扬子大桥股份有限公司</td>\n",
       "      <td>S19|通锡高速</td>\n",
       "      <td>2015-01-04 00:00:00</td>\n",
       "      <td>空心板梁</td>\n",
       "      <td>预应力砼空心板</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支</td>\n",
       "      <td>预制</td>\n",
       "      <td>1,2,3,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6426</th>\n",
       "      <td>世业洲主线高架桥</td>\n",
       "      <td>润扬大桥高速公路有限公司</td>\n",
       "      <td>G4011|扬溧高速</td>\n",
       "      <td>2015-01-02 00:00:00</td>\n",
       "      <td>箱形梁</td>\n",
       "      <td>部分预应力钢筋混凝土</td>\n",
       "      <td>上承</td>\n",
       "      <td>简支连续</td>\n",
       "      <td>无</td>\n",
       "      <td>1,2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6427 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  桥梁名称          单位名称         路线号                跨（孔）号  \\\n",
       "0       204国道分离式立交(上行)  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-14 00:00:00   \n",
       "1       204国道分离式立交(上行)  江苏汾灌高速公路有限公司    G15|沈海高速                18-29   \n",
       "2       204国道分离式立交(上行)  江苏汾灌高速公路有限公司    G15|沈海高速                15-17   \n",
       "3       204国道分离式立交(下行)  江苏汾灌高速公路有限公司    G15|沈海高速                14-16   \n",
       "4       204国道分离式立交(下行)  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-13 00:00:00   \n",
       "5       204国道分离式立交(下行)  江苏汾灌高速公路有限公司    G15|沈海高速                17-29   \n",
       "6              220分离立交  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-20 00:00:00   \n",
       "7                 八农中桥  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-04 00:00:00   \n",
       "8             白石公路分离立交  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-03 00:00:00   \n",
       "9              班庄互通C匝道  江苏汾灌高速公路有限公司    G25|长深高速  2015-01-04 00:00:00   \n",
       "10           板新公路跨主线大桥  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-13 00:00:00   \n",
       "11         板新立交跨陈户大河中桥  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-03 00:00:00   \n",
       "12              潮河口村中桥  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-03 00:00:00   \n",
       "13              陈户大河大桥  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-07 00:00:00   \n",
       "14                陈户中桥  江苏汾灌高速公路有限公司    G15|沈海高速  2015-01-05 00:00:00   \n",
       "15           城南枢纽A匝道中桥  江苏汾灌高速公路有限公司    G25|长深高速  2015-01-04 00:00:00   \n",
       "16    城南枢纽B匝道上跨汾灌高速公路桥  江苏汾灌高速公路有限公司    G25|长深高速  2015-10-13 00:00:00   \n",
       "17    城南枢纽B匝道上跨汾灌高速公路桥  江苏汾灌高速公路有限公司    G25|长深高速            1-9,14-18   \n",
       "18           城南枢纽B匝道中桥  江苏汾灌高速公路有限公司    G25|长深高速  2015-01-04 00:00:00   \n",
       "19            城南枢纽C匝道桥  江苏汾灌高速公路有限公司    G25|长深高速  2015-01-07 00:00:00   \n",
       "20            城南枢纽D匝道桥  江苏汾灌高速公路有限公司    G25|长深高速  2015-01-04 00:00:00   \n",
       "21            城南枢纽E匝道桥  江苏汾灌高速公路有限公司    G25|长深高速  2015-01-08 00:00:00   \n",
       "22             城南枢纽F匝道  江苏汾灌高速公路有限公司    G25|长深高速  2015-01-08 00:00:00   \n",
       "23             城南枢纽G匝道  江苏汾灌高速公路有限公司    G25|长深高速                25-28   \n",
       "24             城南枢纽G匝道  江苏汾灌高速公路有限公司    G25|长深高速  2015-06-09 00:00:00   \n",
       "25             城南枢纽G匝道  江苏汾灌高速公路有限公司    G25|长深高速            1-5,10-24   \n",
       "26             城南枢纽主线桥  江苏汾灌高速公路有限公司    G25|长深高速                18-21   \n",
       "27             城南枢纽主线桥  江苏汾灌高速公路有限公司    G25|长深高速          11-17,22-25   \n",
       "28             城南枢纽主线桥  江苏汾灌高速公路有限公司    G25|长深高速            1-2,36-37   \n",
       "29             城南枢纽主线桥  江苏汾灌高速公路有限公司    G25|长深高速  2015-03-10 00:00:00   \n",
       "...                ...           ...         ...                  ...   \n",
       "6397             大寨河小桥  江苏扬子大桥股份有限公司    S19|通锡高速                    1   \n",
       "6398             大寨河小桥  江苏扬子大桥股份有限公司    S19|通锡高速                    3   \n",
       "6399             大寨河小桥  江苏扬子大桥股份有限公司    S19|通锡高速                    2   \n",
       "6400          江阴大桥半路半桥  江苏扬子大桥股份有限公司     G2|京沪高速  2015-01-07 00:00:00   \n",
       "6401           江阴大桥北引桥  江苏扬子大桥股份有限公司     G2|京沪高速  2015-01-29 00:00:00   \n",
       "6402           江阴大桥北引桥  江苏扬子大桥股份有限公司     G2|京沪高速                30-34   \n",
       "6403           江阴大桥南引桥  江苏扬子大桥股份有限公司     G2|京沪高速  2015-01-03 00:00:00   \n",
       "6404             山凹口大桥  江苏扬子大桥股份有限公司     G2|京沪高速  2015-01-13 00:00:00   \n",
       "6405             山凹口大桥  江苏扬子大桥股份有限公司     G2|京沪高速                14-29   \n",
       "6406        硕放枢纽G匝道1#桥  江苏扬子大桥股份有限公司    S19|通锡高速                20-22   \n",
       "6407        硕放枢纽G匝道1#桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-03 00:00:00   \n",
       "6408        硕放枢纽G匝道1#桥  江苏扬子大桥股份有限公司    S19|通锡高速                23-29   \n",
       "6409        硕放枢纽G匝道1#桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-04-19 00:00:00   \n",
       "6410        硕放枢纽H匝道1#桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-08 00:00:00   \n",
       "6411        硕放枢纽H匝道1#桥  江苏扬子大桥股份有限公司    S19|通锡高速                13-16   \n",
       "6412        硕放枢纽H匝道1#桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-09-12 00:00:00   \n",
       "6413          硕放枢纽O匝道桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-06 00:00:00   \n",
       "6414         硕放枢纽P1匝道桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-03 00:00:00   \n",
       "6415         硕放枢纽P2匝道桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-06 00:00:00   \n",
       "6416           硕放枢纽主线桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-17 00:00:00   \n",
       "6417           硕放枢纽主线桥  江苏扬子大桥股份有限公司    S19|通锡高速                21-40   \n",
       "6418           硕放枢纽主线桥  江苏扬子大桥股份有限公司    S19|通锡高速                18-20   \n",
       "6419           硕放枢纽主线桥  江苏扬子大桥股份有限公司    S19|通锡高速                41-43   \n",
       "6420           硕放枢纽主线桥  江苏扬子大桥股份有限公司    S19|通锡高速                44-46   \n",
       "6421             苏家湾中桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-03 00:00:00   \n",
       "6422             吴花浜中桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-03 00:00:00   \n",
       "6423             西香湾小桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-03 00:00:00   \n",
       "6424          锡宅路主线上跨桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-01 00:00:00   \n",
       "6425             兴南路中桥  江苏扬子大桥股份有限公司    S19|通锡高速  2015-01-04 00:00:00   \n",
       "6426          世业洲主线高架桥  润扬大桥高速公路有限公司  G4011|扬溧高速  2015-01-02 00:00:00   \n",
       "\n",
       "           结构类型          材料 桥面板位置  受力形式     施工方式  \\\n",
       "0           箱形梁  部分预应力钢筋混凝土    上承  简支连续     预制安装   \n",
       "1           箱形梁  部分预应力钢筋混凝土    上承  简支连续     预制安装   \n",
       "2           箱形梁  预应力混凝土连续箱梁    上承    连续     支架现浇   \n",
       "3           箱形梁  预应力混凝土连续箱梁    上承    连续     支架现浇   \n",
       "4           箱形梁  部分预应力钢筋混凝土    上承  简支连续     预制安装   \n",
       "5           箱形梁  部分预应力钢筋混凝土    上承  简支连续     预制安装   \n",
       "6           箱形梁  部分预应力钢筋混凝土    上承  简支连续     预制安装   \n",
       "7          空心板梁     预应力砼空心板    上承  简支连续     预制安装   \n",
       "8          空心板梁     预应力砼空心板    上承    简支     预制安装   \n",
       "9      预应力砼现浇箱梁  预应力混凝土连续箱梁    上承    连续    预应力连续   \n",
       "10          箱形梁       钢筋混凝土    上承    连续     支架现浇   \n",
       "11         空心板梁     预应力砼空心板    上承    简支     预制安装   \n",
       "12         空心板梁     预应力砼空心板    上承  简支连续     预制安装   \n",
       "13         空心板梁     预应力砼空心板    上承    简支     预制安装   \n",
       "14         空心板梁     预应力砼空心板    上承    简支     预制安装   \n",
       "15         空心板梁     预应力砼空心板    上承    简支    简支预应力   \n",
       "16          叠合梁         钢-砼    上承    连续      叠合梁   \n",
       "17     预应力砼现浇箱梁   现浇钢筋混凝土箱梁    上承    连续      现浇砼   \n",
       "18          箱形梁   现浇钢筋混凝土箱梁    上承    连续    现浇钢筋砼   \n",
       "19     预应力砼现浇箱梁  预应力混凝土连续箱梁    上承    连续    预应力现浇   \n",
       "20     预应力砼现浇箱梁  预应力混凝土连续箱梁    上承    连续    预应力现浇   \n",
       "21    现浇钢筋砼连续板梁       钢筋混凝土    上承    连续    现浇钢筋砼   \n",
       "22          箱形梁       钢筋混凝土    上承    连续   搭设支架现浇   \n",
       "23     预应力砼现浇箱梁  预应力混凝土连续箱梁    上承    连续    预应力现浇   \n",
       "24          叠合梁         钢-砼    上承    连续   钢梁与砼结合   \n",
       "25          箱形梁   现浇钢筋混凝土箱梁    上承    连续       现浇   \n",
       "26          叠合梁         钢-砼    上承  连续刚构     钢砼结合   \n",
       "27          箱形梁   现浇钢筋混凝土箱梁    上承    连续     现浇连续   \n",
       "28     预应力砼现浇箱梁  预应力混凝土连续箱梁    上承    连续    预应力连续   \n",
       "29        组合式箱粱    预应力砼组合箱梁    上承    连续       预制   \n",
       "...         ...         ...   ...   ...      ...   \n",
       "6397     板梁（实心）     预应力砼空心板    上承    简支       预制   \n",
       "6398     板梁（实心）     预应力砼空心板    上承    简支       预制   \n",
       "6399     板梁（实心）     预应力砼空心板    上承    简支       预制   \n",
       "6400        箱形梁   现浇钢筋混凝土箱梁    上承    连续      支架法   \n",
       "6401        T形梁       钢筋混凝土    上承    连续   先预制后拼装   \n",
       "6402        箱形梁       钢筋混凝土    上承    连续   满堂支架现浇   \n",
       "6403   预应力砼现浇箱梁  预应力混凝土连续箱梁    上承    连续       现浇   \n",
       "6404        箱形梁  预应力混凝土连续箱梁    上承    连续       现浇   \n",
       "6405   预应力砼现浇箱梁   现浇钢筋混凝土箱梁    上承    连续   满堂支架现浇   \n",
       "6406        箱形梁         结构钢    上承    连续     顶推施工   \n",
       "6407        箱形梁  预应力混凝土连续箱梁    上承    连续  满堂支架现浇砼   \n",
       "6408        箱形梁   现浇钢筋混凝土箱梁    上承    连续  满堂支架现浇砼   \n",
       "6409        箱形梁   现浇钢筋混凝土箱梁    上承    连续  满堂支架现浇砼   \n",
       "6410        箱形梁   现浇钢筋混凝土箱梁    上承    连续  满堂支架现浇砼   \n",
       "6411        箱形梁   现浇钢筋混凝土箱梁    上承    连续  满堂支架现浇砼   \n",
       "6412        箱形梁         结构钢    上承    连续     顶推施工   \n",
       "6413        箱形梁    预应力钢筋混凝土    上承    连续       现浇   \n",
       "6414        箱形梁       钢筋混凝土    上承    连续       现浇   \n",
       "6415        箱形梁       钢筋混凝土    上承    连续       现浇   \n",
       "6416        箱形梁       钢筋混凝土    上承    连续       现浇   \n",
       "6417        箱形梁       钢筋混凝土    上承    连续       现浇   \n",
       "6418        箱形梁    预应力砼组合箱梁    上承    连续       现浇   \n",
       "6419        箱形梁  预应力混凝土连续箱梁    上承    连续       现浇   \n",
       "6420        箱形梁       钢筋混凝土    上承    连续       现浇   \n",
       "6421       空心板梁     预应力砼空心板    上承    简支   先预制后拼装   \n",
       "6422       空心板梁     预应力砼空心板    上承    简支   先预制后拼装   \n",
       "6423       空心板梁     预应力砼空心板    上承    简支     预制拼装   \n",
       "6424       空心板梁     预应力砼空心板    上承    简支     预制拼装   \n",
       "6425       空心板梁     预应力砼空心板    上承    简支       预制   \n",
       "6426        箱形梁  部分预应力钢筋混凝土    上承  简支连续        无   \n",
       "\n",
       "                                                   跨号列表  \n",
       "0                      1,2,3,4,5,6,7,8,9,10,11,12,13,14  \n",
       "1                   18,19,20,21,22,23,24,25,26,27,28,29  \n",
       "2                                              15,16,17  \n",
       "3                                              14,15,16  \n",
       "4                         1,2,3,4,5,6,7,8,9,10,11,12,13  \n",
       "5                17,18,19,20,21,22,23,24,25,26,27,28,29  \n",
       "6     1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1...  \n",
       "7                                               1,2,3,4  \n",
       "8                                                 1,2,3  \n",
       "9                                               1,2,3,4  \n",
       "10                        1,2,3,4,5,6,7,8,9,10,11,12,13  \n",
       "11                                                1,2,3  \n",
       "12                                                1,2,3  \n",
       "13                                        1,2,3,4,5,6,7  \n",
       "14                                            1,2,3,4,5  \n",
       "15                                              1,2,3,4  \n",
       "16                                          10,11,12,13  \n",
       "17                     1,2,3,4,5,6,7,8,9,14,15,16,17,18  \n",
       "18                                              1,2,3,4  \n",
       "19                                        1,2,3,4,5,6,7  \n",
       "20                                              1,2,3,4  \n",
       "21                                      1,2,3,4,5,6,7,8  \n",
       "22                                      1,2,3,4,5,6,7,8  \n",
       "23                                          25,26,27,28  \n",
       "24                                              6,7,8,9  \n",
       "25    1,2,3,4,5,10,11,12,13,14,15,16,17,18,19,20,21,...  \n",
       "26                                          18,19,20,21  \n",
       "27                     11,12,13,14,15,16,17,22,23,24,25  \n",
       "28                                            1,2,36,37  \n",
       "29                                     3,4,5,6,7,8,9,10  \n",
       "...                                                 ...  \n",
       "6397                                                  1  \n",
       "6398                                                  3  \n",
       "6399                                                  2  \n",
       "6400                                      1,2,3,4,5,6,7  \n",
       "6401  1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1...  \n",
       "6402                                     30,31,32,33,34  \n",
       "6403                                              1,2,3  \n",
       "6404                      1,2,3,4,5,6,7,8,9,10,11,12,13  \n",
       "6405    14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29  \n",
       "6406                                           20,21,22  \n",
       "6407                                              1,2,3  \n",
       "6408                               23,24,25,26,27,28,29  \n",
       "6409          4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19  \n",
       "6410                                    1,2,3,4,5,6,7,8  \n",
       "6411                                        13,14,15,16  \n",
       "6412                                         9,10,11,12  \n",
       "6413                                        1,2,3,4,5,6  \n",
       "6414                                              1,2,3  \n",
       "6415                                        1,2,3,4,5,6  \n",
       "6416          1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17  \n",
       "6417  21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,3...  \n",
       "6418                                           18,19,20  \n",
       "6419                                           41,42,43  \n",
       "6420                                           44,45,46  \n",
       "6421                                              1,2,3  \n",
       "6422                                              1,2,3  \n",
       "6423                                              1,2,3  \n",
       "6424                                                  1  \n",
       "6425                                            1,2,3,4  \n",
       "6426                                                1,2  \n",
       "\n",
       "[6427 rows x 10 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import re\n",
    "df = pd.read_excel(\"data/上部结构.xls\")\n",
    "def kuahao_process(x):\n",
    "    result = []\n",
    "    x = x.strip()\n",
    "    match1 = re.match(r'2015-(\\d+)-(\\d+).*', x)#匹配样例；2015-1-14 00:00:00\"\n",
    "    match2 = re.match(r'(\\d+)-(\\d+)', x)#匹配样例18-29\n",
    "    match3 = re.match(r'(\\d+)',x)#匹配样例1,\n",
    "    if match1:\n",
    "        result.extend(list(range(int(match1.group(1)),int(match1.group(2))+1)))\n",
    "        return result\n",
    "    elif match2:\n",
    "        result.extend(list(range(int(match2.group(1)),int(match2.group(2))+1)))\n",
    "        return result\n",
    "    elif match3:\n",
    "        result.append(int(match3.group(1)))\n",
    "        return result\n",
    "    else:\n",
    "        return result\n",
    "\n",
    "    \n",
    "def getKuahaolist(x):\n",
    "    kuahao_unprocess_list = x.split(',')\n",
    "    kuahao_process_list = []\n",
    "    for kuahao in kuahao_unprocess_list:\n",
    "        kuahao_process_list.extend(kuahao_process(kuahao))\n",
    "    if len(kuahao_process_list)== 0:\n",
    "        return 'nan'\n",
    "    else:\n",
    "        return  ','.join(str(v) for v in kuahao_process_list)\n",
    "\n",
    "df['跨号列表'] = df['跨（孔）号'].astype(str).map(getKuahaolist)\n",
    "df\n",
    "# print(getKuahaolist(\"1-9,14-18\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "189,190,195,220,235\n"
     ]
    }
   ],
   "source": [
    "print(getKuahaolist(\"189-190,195,220,235\"))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
